package com.showde.shoppingmall.db.constant;

public class UserConstant extends ConstantBase {

	public static final String TABLENAME = "t_user";

	public static final String USERID = "USERID";
	public static final String USERACCOUNT = "USERACCOUNT";
	public static final String USERNAME = "USERNAME";
	public static final String USERPASSWORD = "USERPASSWORD";
	public static final String USERNICKNAME = "USERNICKNAME";
	public static final String USERCARDTYPE = "USERCARDTYPE";
	public static final String USERCARDNUM = "USERCARDNUM";
	public static final String USERGENDER = "USERGENDER";
	public static final String USERPHONE = "USERPHONE";
	public static final String USERMOBILE = "USERMOBILE";
	public static final String USEREMAIL = "USEREMAIL";
	public static final String USERQQ = "USERQQ";
	public static final String USERMSN = "USERMSN";
	public static final String USEROTHER = "USEROTHER";
	public static final String USERCOUNTRY = "USERCOUNTRY";
	public static final String USERPROVINCE = "USERPROVINCE";
	public static final String USERCITY = "USERCITY";
	public static final String USERPOSTCODE = "USERPOSTCODE";
	public static final String USERREMARK = "USERREMARK";
	public static final String USERCREATETIME = "USERCREATETIME";
	public static final String USERMODIFYTIME = "USERMODIFYTIME";
	public static final String USERHEADICON = "USERHEADICON";

	public static final int COLUMN_USERID = 1;
	public static final int COLUMN_USERACCOUNT = 2;
	public static final int COLUMN_USERNAME = 3;
	public static final int COLUMN_USERPASSWORD = 4;
	public static final int COLUMN_USERNICKNAME = 5;
	public static final int COLUMN_USERCARDTYPE = 6;
	public static final int COLUMN_userCardNum = 7;
	public static final int COLUMN_USERGENDER = 8;
	public static final int COLUMN_USERPHONE = 9;
	public static final int COLUMN_USERMOBILE = 10;
	public static final int COLUMN_USEREMAIL = 11;
	public static final int COLUMN_USERQQ = 12;
	public static final int COLUMN_USERMSN = 13;
	public static final int COLUMN_USEROTHER = 14;
	public static final int COLUMN_USERCOUNTRY = 15;
	public static final int COLUMN_USERPROVINCE = 16;
	public static final int COLUMN_USERCITY = 17;
	public static final int COLUMN_USERPOSTCODE = 18;
	public static final int COLUMN_USERREMARK = 19;
	public static final int COLUMN_USERCREATETIME = 20;
	public static final int COLUMN_USERMODIFYTIME = 21;
	public static final int COLUMN_USERHEADICON = 22;

	public static final String[] dbColumns = new String[] { USERID,
			USERACCOUNT, USERNAME, USERPASSWORD, USERNICKNAME, USERCARDTYPE,
			USERCARDNUM, USERGENDER, USERPHONE, USERMOBILE, USEREMAIL, USERQQ,
			USERMSN, USEROTHER, USERCOUNTRY, USERPROVINCE, USERCITY,
			USERPOSTCODE, USERREMARK, USERCREATETIME, USERMODIFYTIME, USERHEADICON };

	public static final String SQL_CREAT = "CREATE TABLE 't_user'("
			+ "'_id' int primery key ,"
			+ "'USERID' varchar (20) NOT NULL UNIQUE ,"
			+ "'USERACCOUNT' varchar (20) NOT NULL ,"
			+ "'USERNAME' varchar (20) NOT NULL ,"
			+ "'USERPASSWORD' varchar (20) NOT NULL ,"
			+ "'USERNICKNAME' varchar (20) ,"
			+ "'USERCARDTYPE' varchar (5) ,"
			+ "'USERCARDNUM' varchar (20) ," 
			+ "'USERGENDER' varchar (5) ,"
			+ "'USERPHONE' varchar (13) ," 
			+ "'USERMOBILE' varchar (13) ,"
			+ "'USEREMAIL' varchar (30) ," 
			+ "'USERQQ' varchar (12) ,"
			+ "'USERMSN' varchar (30) ," 
			+ "'USEROTHER' varchar (20) ,"
			+ "'USERCOUNTRY' varchar (10) ,"
			+ "'USERPROVINCE' varchar (10) ," 
			+ "'USERCITY' varchar (10) ,"
			+ "'USERPOSTCODE' varchar (10) ,"
			+ "'USERREMARK' varchar (100) ,"
			+ "'USERCREATETIME' varchar (20) ,"
			+ "'USERMODIFYTIME' varchar (20) ,"
			+ "'USERHEADICON' varchar (20))";
}
